<body>
MySQL Driver(Connector/J) adapter for Scriptella. 
<p>See <a href="../../jdbc/package-summary.html#package_description">Overview of JDBC package</a> for a description of common features and connection properties.</p>
<h2>General information</h2>
<table>
    <tr>
        <td><b>Driver class:</b></td><td><code>scriptella.driver.mysql.Driver</code></td>
    </tr>
    <tr>
        <td><b>URL:</b></td><td><code>Same as for MySQL JDBC Driver.</code></td>
    </tr>
    <tr>
        <td><b>Runtime dependencies:</b></td>
        <td><code><a href="http://www.mysql.com/products/connector/j/">mysql-connector-java.jar</a></code></td>
    </tr>
</table>
<h2>Driver Specific Properties</h2>
<table border="1">
    <tr>
        <th>Name</th>
        <th>Description</th>
        <th>Required</th>
    </tr>
    <tr>
        <td>statement.fetchSize</th>
        <td>For MySQL, set the value of this property to Integer.MIN_VALUE, in order to avoid loading all rows into memory:
        <pre><code>statement.fetchSize = -2147483648</code></pre>
        See <a href="http://bugs.mysql.com/bug.php?id=18148">MySQL bug #18148</a>.
        </td>
        <td>No, default value is determined by Connector/J JDBC driver.</th>
    </tr>    
    
</table>

<h2>Examples</h2>
<code><pre>
    &lt;connection driver="mysql" url="jdbc:mysql://localhost:3306/test" user="username" password="password"&gt;
    &lt;/connection&gt;
</pre></code>
The following example specifies a custom delimiter for statements. 
This feature is similar to MySQL client <a href="http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html">""DELIMITER" command</a>.
<br><b>Notes:</b>
<ul>
<li>Delimiter is declared once and cannot be changed, so a separate connection might be necessary for processing SQL with a different delimiter.
<li>DELIMITER command <b>should not</b> be used in scripts and queries.
</ul>

<code><pre>
    &lt;connection driver="mysql" url="jdbc:mysql://localhost:3306/test" user="username" password="password"&gt;
    	 statement.separator=$$ 
    &lt;/connection&gt;
</pre></code>

</body>